﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_CFG_SETTING_MGT_Update')
	BEGIN
		DROP Procedure usp_UPDMS_CFG_SETTING_MGT_Update
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_CFG_SETTING_MGT_Update
**	Desc : 설정관리를 수정한다.
**	Test Exec Query : Exec usp_UPDMS_CFG_SETTING_MGT_Update
**	Called by : Cfg_Dac_UPDMS_CFG_SETTING_MGT.cs
**	Program ID : Cfg1011m
**	Auth : 송시명
**	Date : 2013-05-13
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_CFG_SETTING_MGT_Update]
@Seq int,
@Setting_Nm nvarchar(200),
@Setting_Cd nvarchar(20),
@Setting_Value nvarchar(200),
@Remark nvarchar(1000),
@Use_Yn nvarchar(1),
@Create_User nvarchar(20),
@Create_Dt datetime,
@Update_User nvarchar(20),
@Update_Dt datetime
AS
SET NOCOUNT OFF

UPDATE UPDMS_CFG_SETTING_MGT
   SET Setting_Nm = @Setting_Nm,
       Setting_Cd = @Setting_Cd,
       Setting_Value = @Setting_Value,
       Remark = @Remark,
       Use_Yn = @Use_Yn,
       Update_User = @Update_User,
       Update_Dt = GETDATE()
 WHERE Seq = @Seq

GO